BI-VenkatReddy - 2017-05-09 - 32429 - NA open and shipped revenue extract (Mark Harris by 2017-05-10) #wipdoc
SPECIFICATIONS
32429 - NA open and shipped revenue extract
Purpose
Need to develop the new reports to get the NA open revenue and shipped revenue.
Admin Info
Purpose
|
Need to develop the new reports to get the NA open revenue and shipped revenue.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Venkateswara Reddy D
|
Spec Created Date
|
05-09-2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
|
Document Status
|
WIP
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
|
3
|
Development/ Config
|
|
4
|
Unit test in DEV
|
|
5
|
Unit test in QUA
|
|
6
|
Other activity
|
|
|
TOTAL
|
|
References
Prior Tickets
None
Documents
Spec Changes
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to develop the reports to get the Open and open contract and shipped information.
In Scope:
Need to create three new reports to get the open and shipped revenue.
Out of Scope:
Solution Summary
1. Need to build new reports open revenue, open contract revenue and Shipped revenue.
2. Need to export the output in .xls format.
3. Need to combine the three sheets data into one sheet based on the delivery date.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
001
|
Need to test the performance of the reports in development
|
Reports ran successfully and no issues in performance.
|
002
|
Need to run the reports by pointing the source to quality
|
|
|
|
|
Solution Details
1. Need to build new reports open revenue, open contract revenue and Shipped revenue.
2. Need to export the output in .xls format.
3. Need to combine the three sheets data into one sheet based on the delivery date.
Issues
1. Shipped revenue report Performance is poor in production.